package com.kcyu.sfherp.mapper.ck;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kcyu.sfherp.entity.CkSale;
import com.kcyu.sfherp.entity.CkSaleLine;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CkSaleLineMapper extends BaseMapper<CkSaleLine> {

    @Select("SELECT * FROM SaleLine WHERE BillID = N'${BillID}'")
    public List<CkSaleLine> queryByBillID(@Param("BillID") String BillID);

    @Select("SELECT * FROM PurLine WHERE BillID = N'${BillID}'")
    public List<CkSaleLine> queryPurByBillID(@Param("BillID") String BillID);
}

